Paul Newcome
Paul Newcome
-
Re: Error reports
You can create a helper column (I use checkboxes personally) called Error. You can then enter the following formula and dragfill on down. =IF(ISERROR([First Column Name]@row:[Last Column Name]@row), …1 · -
Re: #Incorrect Argument Set
You still haven't closed out your AND functions. They should be closed BEFORE the output. You have IF(AND("this" = "this", "that" = "that", "output")…1 · -
Re: Join Formula, bringing data from one sheet to another for Procurement use
You would use a JOIN/COLLECT along the lines of =JOIN(COLLECT({Email Column}, {Commodity Column}, @cell = [Commodity Group]@row, {Location Column}, @cell = Location@row), "; ")2 · -
Re: Highlight Weekend Dates
You would need to insert a helper column and use conditional formatting based on that. I would suggest a text/number column with the following column formula that will output "Weekend" on r…1 · -
Re: Formula help please! What formula to mark the parent row "Complete" with an "Not Applicable" task?
Yes. Once you apply a formula to a cell, it will overwrite any data that was previously in it. It looks like your formula is designed to be a rollup type of output for child rows, so it should only b…1 ·
